CREATE TABLE [dbo].[TTTIPO_FINA]
(
[CO_TIPO_FINA] [varchar] (3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[CO_TIPO_DOCU] [varchar] (3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[DE_TIPO_FINA] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ST_GENE_CXPA] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL CONSTRAINT [DF__TTTIPO_FI__ST_GE__3019FEA4] DEFAULT ('N'),
[ST_DOCU_BANC] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL CONSTRAINT [DF__TTTIPO_FI__ST_DO__32024716] DEFAULT ('N'),
[ST_DOCU_CLIE] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL CONSTRAINT [DF__TTTIPO_FI__ST_DO__33EA8F88] DEFAULT ('N'),
[ST_DOCU_PROV] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL CONSTRAINT [DF__TTTIPO_FI__ST_DO__35D2D7FA] DEFAULT ('N'),
[CO_USUA_CREA] [varchar] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL CONSTRAINT [DF__TTTIPO_FI__CO_US__37BB206C] DEFAULT (suser_sname()),
[FE_USUA_CREA] [datetime] NULL CONSTRAINT [DF__TTTIPO_FI__FE_US__38AF44A5] DEFAULT (getdate()),
[CO_USUA_MODI] [varchar] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL CONSTRAINT [DF__TTTIPO_FI__CO_US__39A368DE] DEFAULT (suser_sname()),
[FE_USUA_MODI] [datetime] NULL CONSTRAINT [DF__TTTIPO_FI__FE_US__3A978D17] DEFAULT (getdate())
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[TTTIPO_FINA] WITH NOCHECK ADD CONSTRAINT [CK__TTTIPO_FI__ST_DO__32F66B4F] CHECK NOT FOR REPLICATION (([ST_DOCU_BANC]='N' OR [ST_DOCU_BANC]='S'))
GO
ALTER TABLE [dbo].[TTTIPO_FINA] WITH NOCHECK ADD CONSTRAINT [CK__TTTIPO_FI__ST_DO__34DEB3C1] CHECK NOT FOR REPLICATION (([ST_DOCU_CLIE]='N' OR [ST_DOCU_CLIE]='S'))
GO
ALTER TABLE [dbo].[TTTIPO_FINA] WITH NOCHECK ADD CONSTRAINT [CK__TTTIPO_FI__ST_DO__36C6FC33] CHECK NOT FOR REPLICATION (([ST_DOCU_PROV]='N' OR [ST_DOCU_PROV]='S'))
GO
ALTER TABLE [dbo].[TTTIPO_FINA] WITH NOCHECK ADD CONSTRAINT [CK__TTTIPO_FI__ST_GE__310E22DD] CHECK NOT FOR REPLICATION (([ST_GENE_CXPA]='N' OR [ST_GENE_CXPA]='S'))
GO
ALTER TABLE [dbo].[TTTIPO_FINA] ADD CONSTRAINT [PK__TTTIPO_F__B18EB02F3553B50D] PRIMARY KEY CLUSTERED  ([CO_TIPO_FINA]) ON [PRIMARY]
GO
